Pandas Profiling Report

Dataset statistics

Number of variables	16
Number of observations	6362620
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	564.3 MiB
Average record size in memory	93.0 B

Variable types

Numeric	7
Categorical	9

Alerts

`nameOrig` has a high cardinality: 6353307 distinct values	High cardinality
`nameDest` has a high cardinality: 2722362 distinct values	High cardinality
`amount` is highly overall correlated with `oldbalanceDest` and 1 other fields	High correlation
`oldbalanceOrig` is highly overall correlated with `newbalanceOrig`	High correlation
`newbalanceOrig` is highly overall correlated with `oldbalanceOrig`	High correlation
`oldbalanceDest` is highly overall correlated with `amount` and 1 other fields	High correlation
`newbalanceDest` is highly overall correlated with `amount` and 1 other fields	High correlation
`CASH_OUT` is highly overall correlated with `PAYMENT`	High correlation
`PAYMENT` is highly overall correlated with `CASH_OUT`	High correlation
`isFraud` is highly imbalanced (98.6%)	Imbalance
`isFlaggedFraud` is highly imbalanced (> 99.9%)	Imbalance
`DEBIT` is highly imbalanced (94.3%)	Imbalance
`TRANSFER` is highly imbalanced (58.5%)	Imbalance
`amount` is highly skewed (γ1 = 30.99394948)	Skewed
`nameOrig` is uniformly distributed	Uniform
`oldbalanceOrig` has 2102449 (33.0%) zeros	Zeros
`newbalanceOrig` has 3609566 (56.7%) zeros	Zeros
`oldbalanceDest` has 2704388 (42.5%) zeros	Zeros
`newbalanceDest` has 2439433 (38.3%) zeros	Zeros
`day` has 571039 (9.0%) zeros	Zeros
`hour` has 71587 (1.1%) zeros	Zeros

Reproduction

Analysis started	2023-04-25 14:11:35.881651
Analysis finished	2023-04-25 14:26:38.076629
Duration	15 minutes and 2.19 seconds
Software version	ydata-profiling vv4.0.0
Download configuration	config.json

amount
Real number (ℝ)

HIGH CORRELATION SKEWED

Distinct	5316900
Distinct (%)	83.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	179861.9

Minimum	0
Maximum	92445517
Zeros	16
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	48.5 MiB

Quantile statistics

Minimum	0
5-th percentile	2224.0995
Q1	13389.57
median	74871.94
Q3	208721.48
95-th percentile	518634.2
Maximum	92445517
Range	92445517
Interquartile range (IQR)	195331.91

Descriptive statistics

Standard deviation	603858.23
Coefficient of variation (CV)	3.3573437
Kurtosis	1797.9567
Mean	179861.9
Median Absolute Deviation (MAD)	68393.655
Skewness	30.993949
Sum	1.1443929 × 10¹²
Variance	3.6464476 × 10¹¹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
10000000	3207	0.1%
10000	88	< 0.1%
5000	79	< 0.1%
15000	68	< 0.1%
500	65	< 0.1%
100000	42	< 0.1%
21500	37	< 0.1%
120000	29	< 0.1%
135000	20	< 0.1%
0	16	< 0.1%
Other values (5316890)	6358969	99.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	16	< 0.1%
0.01	1	< 0.1%
0.02	3	< 0.1%
0.03	2	< 0.1%
0.04	1	< 0.1%
0.06	1	< 0.1%
0.07	1	< 0.1%
0.09	1	< 0.1%
0.1	1	< 0.1%
0.11	2	< 0.1%

Value	Count	Frequency (%)
92445516.64	1	< 0.1%
73823490.36	1	< 0.1%
71172480.42	1	< 0.1%
69886731.3	1	< 0.1%
69337316.27	1	< 0.1%
67500761.29	1	< 0.1%
66761272.21	1	< 0.1%
64234448.19	1	< 0.1%
63847992.58	1	< 0.1%
63294839.63	1	< 0.1%

nameOrig
Categorical

HIGH CARDINALITY UNIFORM

Distinct	6353307
Distinct (%)	99.9%
Missing	0
Missing (%)	0.0%
Memory size	48.5 MiB

C1784010646	3
C363736674	3
C2051359467	3
C1902386530	3
C1976208114	3
Other values (6353302)	6362605

Length

Max length	11
Median length	11
Mean length	10.482323
Min length	5

Characters and Unicode

Total characters	66695040
Distinct characters	11
Distinct categories	2 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	6344009 ?
Unique (%)	99.7%

Sample

1st row	C1231006815
2nd row	C1666544295
3rd row	C1305486145
4th row	C840083671
5th row	C2048537720

Common Values

Value	Count	Frequency (%)
C1784010646	3	< 0.1%
C363736674	3	< 0.1%
C2051359467	3	< 0.1%
C1902386530	3	< 0.1%
C1976208114	3	< 0.1%
C1462946854	3	< 0.1%
C400299098	3	< 0.1%
C1999539787	3	< 0.1%
C1530544995	3	< 0.1%
C1677795071	3	< 0.1%
Other values (6353297)	6362590	> 99.9%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
c1784010646	3	< 0.1%
c1530544995	3	< 0.1%
c363736674	3	< 0.1%
c2098525306	3	< 0.1%
c1832548028	3	< 0.1%
c1065307291	3	< 0.1%
c724452879	3	< 0.1%
c1677795071	3	< 0.1%
c545315117	3	< 0.1%
c1999539787	3	< 0.1%
Other values (6353297)	6362590	> 99.9%

Most occurring characters

Value	Count	Frequency (%)
1	8803448	13.2%
C	6362620	9.5%
2	6136135	9.2%
3	5699596	8.5%
4	5693146	8.5%
7	5669437	8.5%
5	5668010	8.5%
6	5667725	8.5%
0	5667074	8.5%
9	5665212	8.5%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	60332420	90.5%
Uppercase Letter	6362620	9.5%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
1	8803448	14.6%
2	6136135	10.2%
3	5699596	9.4%
4	5693146	9.4%
7	5669437	9.4%
5	5668010	9.4%
6	5667725	9.4%
0	5667074	9.4%
9	5665212	9.4%
8	5662637	9.4%

Uppercase Letter

Value	Count	Frequency (%)
C	6362620	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	60332420	90.5%
Latin	6362620	9.5%

Most frequent character per script

Common

Value	Count	Frequency (%)
1	8803448	14.6%
2	6136135	10.2%
3	5699596	9.4%
4	5693146	9.4%
7	5669437	9.4%
5	5668010	9.4%
6	5667725	9.4%
0	5667074	9.4%
9	5665212	9.4%
8	5662637	9.4%

Latin

Value	Count	Frequency (%)
C	6362620	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	66695040	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
1	8803448	13.2%
C	6362620	9.5%
2	6136135	9.2%
3	5699596	8.5%
4	5693146	8.5%
7	5669437	8.5%
5	5668010	8.5%
6	5667725	8.5%
0	5667074	8.5%
9	5665212	8.5%

oldbalanceOrig
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	1845844
Distinct (%)	29.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	833883.1

Minimum	0
Maximum	59585040
Zeros	2102449
Zeros (%)	33.0%
Negative	0
Negative (%)	0.0%
Memory size	48.5 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	14208
Q3	107315.18
95-th percentile	5823702.3
Maximum	59585040
Range	59585040
Interquartile range (IQR)	107315.18

Descriptive statistics

Standard deviation	2888242.7
Coefficient of variation (CV)	3.4636062
Kurtosis	32.964879
Mean	833883.1
Median Absolute Deviation (MAD)	14208
Skewness	5.2491364
Sum	5.3056813 × 10¹²
Variance	8.3419457 × 10¹²
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	2102449	33.0%
184	918	< 0.1%
133	914	< 0.1%
195	912	< 0.1%
164	909	< 0.1%
109	908	< 0.1%
181	908	< 0.1%
157	902	< 0.1%
146	899	< 0.1%
136	898	< 0.1%
Other values (1845834)	4252003	66.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	2102449	33.0%
0.05	1	< 0.1%
0.18	1	< 0.1%
0.21	1	< 0.1%
0.44	1	< 0.1%
0.67	1	< 0.1%
1	370	< 0.1%
1.02	1	< 0.1%
1.37	1	< 0.1%
1.38	1	< 0.1%

Value	Count	Frequency (%)
59585040.37	1	< 0.1%
57316255.05	1	< 0.1%
50399045.08	1	< 0.1%
49585040.37	1	< 0.1%
47316255.05	1	< 0.1%
45674547.89	1	< 0.1%
44892193.09	1	< 0.1%
43818855.3	1	< 0.1%
43686616.33	1	< 0.1%
42542664.27	1	< 0.1%

newbalanceOrig
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	2682586
Distinct (%)	42.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	855113.67

Minimum	0
Maximum	49585040
Zeros	3609566
Zeros (%)	56.7%
Negative	0
Negative (%)	0.0%
Memory size	48.5 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	144258.41
95-th percentile	5980262.3
Maximum	49585040
Range	49585040
Interquartile range (IQR)	144258.41

Descriptive statistics

Standard deviation	2924048.5
Coefficient of variation (CV)	3.4194852
Kurtosis	32.066985
Mean	855113.67
Median Absolute Deviation (MAD)	0
Skewness	5.176884
Sum	5.4407633 × 10¹²
Variance	8.5500596 × 10¹²
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	3609566	56.7%
9011.73	4	< 0.1%
7468.59	4	< 0.1%
8927.38	4	< 0.1%
4019.43	4	< 0.1%
7717.83	4	< 0.1%
36875.73	4	< 0.1%
7070.1	4	< 0.1%
10528.49	4	< 0.1%
7802.01	4	< 0.1%
Other values (2682576)	2753018	43.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	3609566	56.7%
0.01	1	< 0.1%
0.03	1	< 0.1%
0.05	1	< 0.1%
0.12	1	< 0.1%
0.13	1	< 0.1%
0.18	1	< 0.1%
0.21	1	< 0.1%
0.23	1	< 0.1%
0.3	1	< 0.1%

Value	Count	Frequency (%)
49585040.37	1	< 0.1%
47316255.05	1	< 0.1%
43686616.33	1	< 0.1%
43673802.21	1	< 0.1%
41690842.64	1	< 0.1%
41432359.46	1	< 0.1%
40399045.08	1	< 0.1%
39585040.37	1	< 0.1%
38946233.02	1	< 0.1%
38939424.03	1	< 0.1%

nameDest
Categorical

Distinct	2722362
Distinct (%)	42.8%
Missing	0
Missing (%)	0.0%
Memory size	48.5 MiB

C1286084959	113
C985934102	109
C665576141	105
C2083562754	102
C1590550415	101
Other values (2722357)	6362090

Length

Max length	11
Median length	11
Mean length	10.481752
Min length	2

Characters and Unicode

Total characters	66691405
Distinct characters	12
Distinct categories	2 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	2262704 ?
Unique (%)	35.6%

Sample

1st row	M1979787155
2nd row	M2044282225
3rd row	C553264065
4th row	C38997010
5th row	M1230701703

Common Values

Value	Count	Frequency (%)
C1286084959	113	< 0.1%
C985934102	109	< 0.1%
C665576141	105	< 0.1%
C2083562754	102	< 0.1%
C1590550415	101	< 0.1%
C248609774	101	< 0.1%
C1789550256	99	< 0.1%
C451111351	99	< 0.1%
C1360767589	98	< 0.1%
C1023714065	97	< 0.1%
Other values (2722352)	6361596	> 99.9%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
c1286084959	113	< 0.1%
c985934102	109	< 0.1%
c665576141	105	< 0.1%
c2083562754	102	< 0.1%
c1590550415	101	< 0.1%
c248609774	101	< 0.1%
c1789550256	99	< 0.1%
c451111351	99	< 0.1%
c1360767589	98	< 0.1%
c1023714065	97	< 0.1%
Other values (2722352)	6361596	> 99.9%

Most occurring characters

Value	Count	Frequency (%)
1	8799996	13.2%
2	6133780	9.2%
3	5704404	8.6%
4	5691070	8.5%
8	5675627	8.5%
9	5668861	8.5%
7	5665128	8.5%
0	5664751	8.5%
6	5662897	8.5%
5	5662271	8.5%
Other values (2)	6362620	9.5%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	60328785	90.5%
Uppercase Letter	6362620	9.5%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
1	8799996	14.6%
2	6133780	10.2%
3	5704404	9.5%
4	5691070	9.4%
8	5675627	9.4%
9	5668861	9.4%
7	5665128	9.4%
0	5664751	9.4%
6	5662897	9.4%
5	5662271	9.4%

Uppercase Letter

Value	Count	Frequency (%)
C	4211125	66.2%
M	2151495	33.8%

Most occurring scripts

Value	Count	Frequency (%)
Common	60328785	90.5%
Latin	6362620	9.5%

Most frequent character per script

Common

Value	Count	Frequency (%)
1	8799996	14.6%
2	6133780	10.2%
3	5704404	9.5%
4	5691070	9.4%
8	5675627	9.4%
9	5668861	9.4%
7	5665128	9.4%
0	5664751	9.4%
6	5662897	9.4%
5	5662271	9.4%

Latin

Value	Count	Frequency (%)
C	4211125	66.2%
M	2151495	33.8%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	66691405	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
1	8799996	13.2%
2	6133780	9.2%
3	5704404	8.6%
4	5691070	8.5%
8	5675627	8.5%
9	5668861	8.5%
7	5665128	8.5%
0	5664751	8.5%
6	5662897	8.5%
5	5662271	8.5%
Other values (2)	6362620	9.5%

oldbalanceDest
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	3614697
Distinct (%)	56.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1100701.7

Minimum	0
Maximum	3.5601589 × 10⁸
Zeros	2704388
Zeros (%)	42.5%
Negative	0
Negative (%)	0.0%
Memory size	48.5 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	132705.66
Q3	943036.71
95-th percentile	5147229.7
Maximum	3.5601589 × 10⁸
Range	3.5601589 × 10⁸
Interquartile range (IQR)	943036.71

Descriptive statistics

Standard deviation	3399180.1
Coefficient of variation (CV)	3.0881938
Kurtosis	948.67413
Mean	1100701.7
Median Absolute Deviation (MAD)	132705.66
Skewness	19.921758
Sum	7.0033464 × 10¹²
Variance	1.1554425 × 10¹³
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	2704388	42.5%
10000000	615	< 0.1%
20000000	219	< 0.1%
30000000	86	< 0.1%
40000000	31	< 0.1%
102	21	< 0.1%
198	19	< 0.1%
125	18	< 0.1%
132	18	< 0.1%
160	18	< 0.1%
Other values (3614687)	3657187	57.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	2704388	42.5%
0.01	1	< 0.1%
0.03	1	< 0.1%
0.13	1	< 0.1%
0.33	1	< 0.1%
0.37	1	< 0.1%
0.79	1	< 0.1%
1	7	< 0.1%
1.39	1	< 0.1%
1.64	1	< 0.1%

Value	Count	Frequency (%)
356015889.4	1	< 0.1%
355553416.3	1	< 0.1%
355381433.6	1	< 0.1%
355380483.5	1	< 0.1%
355185537.1	1	< 0.1%
328194464.9	1	< 0.1%
327998074.2	1	< 0.1%
327963024	1	< 0.1%
327852121.4	1	< 0.1%
327827763.4	1	< 0.1%

newbalanceDest
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	3555499
Distinct (%)	55.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1224996.4

Minimum	0
Maximum	3.5617928 × 10⁸
Zeros	2439433
Zeros (%)	38.3%
Negative	0
Negative (%)	0.0%
Memory size	48.5 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	214661.44
Q3	1111909.2
95-th percentile	5515715.9
Maximum	3.5617928 × 10⁸
Range	3.5617928 × 10⁸
Interquartile range (IQR)	1111909.2

Descriptive statistics

Standard deviation	3674128.9
Coefficient of variation (CV)	2.9992978
Kurtosis	862.15651
Mean	1224996.4
Median Absolute Deviation (MAD)	214661.44
Skewness	19.352302
Sum	7.7941866 × 10¹²
Variance	1.3499223 × 10¹³
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	2439433	38.3%
10000000	53	< 0.1%
971418.91	32	< 0.1%
19169204.93	29	< 0.1%
16532032.16	25	< 0.1%
1254956.07	25	< 0.1%
1412484.09	22	< 0.1%
1178808.14	21	< 0.1%
4743010.67	21	< 0.1%
7364724.84	21	< 0.1%
Other values (3555489)	3922938	61.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	2439433	38.3%
0.01	1	< 0.1%
0.33	1	< 0.1%
1.39	1	< 0.1%
1.64	1	< 0.1%
1.74	1	< 0.1%
2.15	1	< 0.1%
2.45	1	< 0.1%
2.71	1	< 0.1%
2.76	1	< 0.1%

Value	Count	Frequency (%)
356179278.9	1	< 0.1%
356015889.4	1	< 0.1%
355553416.3	2	< 0.1%
355381433.6	1	< 0.1%
355380483.5	1	< 0.1%
355185537.1	1	< 0.1%
328431698.2	1	< 0.1%
328194464.9	1	< 0.1%
327998074.2	1	< 0.1%
327963024	1	< 0.1%

isFraud
Categorical

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	48.5 MiB

0	6354407
1	8213

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	6362620
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	0
3rd row	1
4th row	1
5th row	0

Common Values

Value	Count	Frequency (%)
0	6354407	99.9%
1	8213	0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0	6354407	99.9%
1	8213	0.1%

Most occurring characters

Value	Count	Frequency (%)
0	6354407	99.9%
1	8213	0.1%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	6362620	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	6354407	99.9%
1	8213	0.1%

Most occurring scripts

Value	Count	Frequency (%)
Common	6362620	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	6354407	99.9%
1	8213	0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	6362620	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	6354407	99.9%
1	8213	0.1%

isFlaggedFraud
Categorical

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	48.5 MiB

0	6362604
1	16

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	6362620
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	0
3rd row	0
4th row	0
5th row	0

Common Values

Value	Count	Frequency (%)
0	6362604	> 99.9%
1	16	< 0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0	6362604	> 99.9%
1	16	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
0	6362604	> 99.9%
1	16	< 0.1%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	6362620	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	6362604	> 99.9%
1	16	< 0.1%

Most occurring scripts

Value	Count	Frequency (%)
Common	6362620	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	6362604	> 99.9%
1	16	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	6362620	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	6362604	> 99.9%
1	16	< 0.1%

day
Real number (ℝ)

Distinct	31
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	9.503158

Minimum	0
Maximum	30
Zeros	571039
Zeros (%)	9.0%
Negative	0
Negative (%)	0.0%
Memory size	48.5 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	6
median	9
Q3	13
95-th percentile	20
Maximum	30
Range	30
Interquartile range (IQR)	7

Descriptive statistics

Standard deviation	5.922111
Coefficient of variation (CV)	0.62317295
Kurtosis	0.33160024
Mean	9.503158
Median Absolute Deviation (MAD)	4
Skewness	0.37754388
Sum	60464983
Variance	35.071398
Monotonicity	Increasing

Histogram with fixed size bins (bins=31)

Value	Count	Frequency (%)
0	571039	9.0%
1	452761	7.1%
7	449147	7.1%
5	440626	6.9%
12	429335	6.7%
16	421098	6.6%
6	420282	6.6%
8	418103	6.6%
10	418006	6.6%
14	400706	6.3%
Other values (21)	1941517	30.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	571039	9.0%
1	452761	7.1%
2	6749	0.1%
3	21904	0.3%
4	12995	0.2%
5	440626	6.9%
6	420282	6.6%
7	449147	7.1%
8	418103	6.6%
9	392886	6.2%

Value	Count	Frequency (%)
30	282	< 0.1%
29	11283	0.2%
28	55037	0.9%
27	14522	0.2%
26	8574	0.1%
25	13893	0.2%
24	58712	0.9%
23	33349	0.5%
22	50432	0.8%
21	52510	0.8%

hour
Real number (ℝ)

Distinct	24
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	15.321454

Minimum	0
Maximum	23
Zeros	71587
Zeros (%)	1.1%
Negative	0
Negative (%)	0.0%
Memory size	48.5 MiB

Quantile statistics

Minimum	0
5-th percentile	9
Q1	12
median	16
Q3	19
95-th percentile	22
Maximum	23
Range	23
Interquartile range (IQR)	7

Descriptive statistics

Standard deviation	4.321799
Coefficient of variation (CV)	0.28207499
Kurtosis	0.68407032
Mean	15.321454
Median Absolute Deviation (MAD)	3
Skewness	-0.60564418
Sum	97484591
Variance	18.677947
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=24)

Value	Count	Frequency (%)
19	647814	10.2%
18	580509	9.1%
20	553728	8.7%
12	483418	7.6%
13	468474	7.4%
11	445992	7.0%
16	441612	6.9%
17	439941	6.9%
14	439653	6.9%
10	425729	6.7%
Other values (14)	1435750	22.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	71587	1.1%
1	27111	0.4%
2	9018	0.1%
3	2007	< 0.1%
4	1241	< 0.1%
5	1641	< 0.1%
6	3420	0.1%
7	8988	0.1%
8	26915	0.4%
9	283518	4.5%

Value	Count	Frequency (%)
23	141257	2.2%
22	194555	3.1%
21	247806	3.9%
20	553728	8.7%
19	647814	10.2%
18	580509	9.1%
17	439941	6.9%
16	441612	6.9%
15	416686	6.5%
14	439653	6.9%

CASH_IN
Categorical

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	48.5 MiB

0	4963336
1	1399284

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	6362620
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	0
3rd row	0
4th row	0
5th row	0

Common Values

Value	Count	Frequency (%)
0	4963336	78.0%
1	1399284	22.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0	4963336	78.0%
1	1399284	22.0%

Most occurring characters

Value	Count	Frequency (%)
0	4963336	78.0%
1	1399284	22.0%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	6362620	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	4963336	78.0%
1	1399284	22.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	6362620	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	4963336	78.0%
1	1399284	22.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	6362620	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	4963336	78.0%
1	1399284	22.0%

CASH_OUT
Categorical

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	48.5 MiB

0	4125120
1	2237500

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	6362620
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	0
3rd row	0
4th row	1
5th row	0

Common Values

Value	Count	Frequency (%)
0	4125120	64.8%
1	2237500	35.2%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0	4125120	64.8%
1	2237500	35.2%

Most occurring characters

Value	Count	Frequency (%)
0	4125120	64.8%
1	2237500	35.2%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	6362620	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	4125120	64.8%
1	2237500	35.2%

Most occurring scripts

Value	Count	Frequency (%)
Common	6362620	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	4125120	64.8%
1	2237500	35.2%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	6362620	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	4125120	64.8%
1	2237500	35.2%

DEBIT
Categorical

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	48.5 MiB

0	6321188
1	41432

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	6362620
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	0
3rd row	0
4th row	0
5th row	0

Common Values

Value	Count	Frequency (%)
0	6321188	99.3%
1	41432	0.7%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0	6321188	99.3%
1	41432	0.7%

Most occurring characters

Value	Count	Frequency (%)
0	6321188	99.3%
1	41432	0.7%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	6362620	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	6321188	99.3%
1	41432	0.7%

Most occurring scripts

Value	Count	Frequency (%)
Common	6362620	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	6321188	99.3%
1	41432	0.7%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	6362620	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	6321188	99.3%
1	41432	0.7%

PAYMENT
Categorical

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	48.5 MiB

0	4211125
1	2151495

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	6362620
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	1
2nd row	1
3rd row	0
4th row	0
5th row	1

Common Values

Value	Count	Frequency (%)
0	4211125	66.2%
1	2151495	33.8%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0	4211125	66.2%
1	2151495	33.8%

Most occurring characters

Value	Count	Frequency (%)
0	4211125	66.2%
1	2151495	33.8%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	6362620	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	4211125	66.2%
1	2151495	33.8%

Most occurring scripts

Value	Count	Frequency (%)
Common	6362620	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	4211125	66.2%
1	2151495	33.8%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	6362620	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	4211125	66.2%
1	2151495	33.8%

TRANSFER
Categorical

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	48.5 MiB

0	5829711
1	532909

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	6362620
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	0
3rd row	1
4th row	0
5th row	0

Common Values

Value	Count	Frequency (%)
0	5829711	91.6%
1	532909	8.4%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0	5829711	91.6%
1	532909	8.4%

Most occurring characters

Value	Count	Frequency (%)
0	5829711	91.6%
1	532909	8.4%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	6362620	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	5829711	91.6%
1	532909	8.4%

Most occurring scripts

Value	Count	Frequency (%)
Common	6362620	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	5829711	91.6%
1	532909	8.4%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	6362620	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	5829711	91.6%
1	532909	8.4%

Auto

Heatmap
Table

	amount	oldbalanceOrig	newbalanceOrig	oldbalanceDest	newbalanceDest	day	hour	isFraud	isFlaggedFraud	CASH_IN	CASH_OUT	DEBIT	PAYMENT	TRANSFER
amount	1.000	0.048	-0.071	0.595	0.670	0.006	-0.078	0.049	0.014	0.016	0.021	0.002	0.022	0.100
oldbalanceOrig	0.048	1.000	0.803	0.024	-0.008	-0.006	-0.002	0.031	0.003	0.425	0.166	0.018	0.162	0.068
newbalanceOrig	-0.071	0.803	1.000	0.044	-0.094	-0.011	0.011	0.019	0.005	0.475	0.186	0.020	0.180	0.076
oldbalanceDest	0.595	0.024	0.044	1.000	0.936	-0.004	-0.015	0.002	0.000	0.003	0.002	0.002	0.022	0.029
newbalanceDest	0.670	-0.008	-0.094	0.936	1.000	-0.004	-0.025	0.002	0.000	0.002	0.004	0.001	0.025	0.052
day	0.006	-0.006	-0.011	-0.004	-0.004	1.000	0.036	0.062	0.006	0.007	0.017	0.008	0.010	0.010
hour	-0.078	-0.002	0.011	-0.015	-0.025	0.036	1.000	0.164	0.006	0.027	0.096	0.043	0.112	0.016
isFraud	0.049	0.031	0.019	0.002	0.002	0.062	0.164	1.000	0.043	0.019	0.011	0.003	0.026	0.054
isFlaggedFraud	0.014	0.003	0.005	0.000	0.000	0.006	0.006	0.043	1.000	0.001	0.001	0.000	0.001	0.005
CASH_IN	0.016	0.425	0.475	0.003	0.002	0.007	0.027	0.019	0.001	1.000	0.391	0.043	0.380	0.161
CASH_OUT	0.021	0.166	0.186	0.002	0.004	0.017	0.096	0.011	0.001	0.391	1.000	0.060	0.526	0.223
DEBIT	0.002	0.018	0.020	0.002	0.001	0.008	0.043	0.003	0.000	0.043	0.060	1.000	0.058	0.024
PAYMENT	0.022	0.162	0.180	0.022	0.025	0.010	0.112	0.026	0.001	0.380	0.526	0.058	1.000	0.216
TRANSFER	0.100	0.068	0.076	0.029	0.052	0.010	0.016	0.054	0.005	0.161	0.223	0.024	0.216	1.000

Count
Matrix

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

First rows
Last rows

	amount	nameOrig	oldbalanceOrig	newbalanceOrig	nameDest	oldbalanceDest	newbalanceDest	isFraud	hour	CASH_OUT	DEBIT	PAYMENT	TRANSFER
0	9839.64	C1231006815	170136.00	160296.36	M1979787155	0.0	0.00	0	1	0	0	1	0
1	1864.28	C1666544295	21249.00	19384.72	M2044282225	0.0	0.00	0	1	0	0	1	0
2	181.00	C1305486145	181.00	0.00	C553264065	0.0	0.00	1	1	0	0	0	1
3	181.00	C840083671	181.00	0.00	C38997010	21182.0	0.00	1	1	1	0	0	0
4	11668.14	C2048537720	41554.00	29885.86	M1230701703	0.0	0.00	0	1	0	0	1	0
5	7817.71	C90045638	53860.00	46042.29	M573487274	0.0	0.00	0	1	0	0	1	0
6	7107.77	C154988899	183195.00	176087.23	M408069119	0.0	0.00	0	1	0	0	1	0
7	7861.64	C1912850431	176087.23	168225.59	M633326333	0.0	0.00	0	1	0	0	1	0
8	4024.36	C1265012928	2671.00	0.00	M1176932104	0.0	0.00	0	1	0	0	1	0
9	5337.77	C712410124	41720.00	36382.23	C195600860	41898.0	40348.79	0	1	0	1	0	0

	amount	nameOrig	oldbalanceOrig	nameDest	oldbalanceDest	newbalanceDest	isFraud	day	hour	CASH_OUT	TRANSFER
6362610	63416.99	C778071008	63416.99	C1812552860	0.00	0.00	1	30	22	0	1
6362611	63416.99	C994950684	63416.99	C1662241365	276433.18	339850.17	1	30	22	1	0
6362612	1258818.82	C1531301470	1258818.82	C1470998563	0.00	0.00	1	30	23	0	1
6362613	1258818.82	C1436118706	1258818.82	C1240760502	503464.50	1762283.33	1	30	23	1	0
6362614	339682.13	C2013999242	339682.13	C1850423904	0.00	0.00	1	30	23	0	1
6362615	339682.13	C786484425	339682.13	C776919290	0.00	339682.13	1	30	23	1	0
6362616	6311409.28	C1529008245	6311409.28	C1881841831	0.00	0.00	1	30	23	0	1
6362617	6311409.28	C1162922333	6311409.28	C1365125890	68488.84	6379898.11	1	30	23	1	0
6362618	850002.52	C1685995037	850002.52	C2080388513	0.00	0.00	1	30	23	0	1
6362619	850002.52	C1280323807	850002.52	C873221189	6510099.11	7360101.63	1	30	23	1	0

Overview

Variables

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Uppercase Letter

Most occurring scripts

Most frequent character per script

Common

Latin

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Uppercase Letter

Most occurring scripts

Most frequent character per script

Common

Latin

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks